1.hdp_lbg_supin_dwd_zp_58_zzdetail
说明：目前创建的都是OLAP引擎

CREATE TABLE `hdp_lbg_supin_dwd_zp_58_zzdetail` (
  `e_time` datetime NULL COMMENT "事件时间",
  `slot` varchar(128) NULL COMMENT "slot",
  `info_type` varchar(64) NULL COMMENT "帖子商业类型",
  `sid` varchar(128) NULL COMMENT "sid",
  `userid` varchar(128) NULL COMMENT "c端userid",
  `imei` varchar(128) NULL COMMENT "imei",
  `imei_md5` varchar(128) NULL COMMENT "",
  `platform` varchar(64) NULL COMMENT "平台",
  `info_id` varchar(128) NULL COMMENT "帖子id ",
  `info_buid` varchar(128) NULL COMMENT "帖子b端userid",
  `tjfrom` varchar(65533) NULL COMMENT "tjform",
  `disp_cate1` varchar(128) NULL COMMENT "帖子表现一级类别",
  `disp_cate2` varchar(128) NULL COMMENT "帖子表现二级级类别",
  `disp_cate3` varchar(128) NULL COMMENT "帖子表现三级类别",
  `disp_cate4` varchar(128) NULL COMMENT "帖子表现四级类别",
  `ad_cate1` varchar(128) NULL COMMENT "帖子归属一级类别",
  `ad_cate2` varchar(128) NULL COMMENT "帖子归属二级类别",
  `ad_cate3` varchar(128) NULL COMMENT "帖子归属三级类别",
  `ad_local1` varchar(128) NULL COMMENT "帖子归属一级地域",
  `ad_local2` varchar(128) NULL COMMENT "帖子归属二级地域",
  `ad_local3` varchar(128) NULL COMMENT "帖子归属三级地域",
  `ad_userid` varchar(128) NULL COMMENT "b端userid",
  `disp_local1` varchar(128) NULL COMMENT "帖子展现一级地域",
  `disp_local2` varchar(128) NULL COMMENT "帖子展现二级地域",
  `disp_local3` varchar(128) NULL COMMENT "帖子展现三级地域",
  `business_line` varchar(64) NULL COMMENT "业务线",
  `cookieid` varchar(128) NULL COMMENT "cookieid",
  `card_type` varchar(128) NULL COMMENT "卡片类型",
  `ip` varchar(64) NULL COMMENT ""
) ENGINE=OLAP
DUPLICATE KEY(`e_time`, `slot`, `info_type`)
COMMENT "58详情日志"
PARTITION BY RANGE(`e_time`)
(PARTITION p20240605 VALUES [('2024-06-05 00:00:00'), ('2024-06-06 00:00:00')),
PARTITION p20240606 VALUES [('2024-06-06 00:00:00'), ('2024-06-07 00:00:00')),
PARTITION p20240607 VALUES [('2024-06-07 00:00:00'), ('2024-06-08 00:00:00')),
PARTITION p20240608 VALUES [('2024-06-08 00:00:00'), ('2024-06-09 00:00:00')),
PARTITION p20240609 VALUES [('2024-06-09 00:00:00'), ('2024-06-10 00:00:00')),
PARTITION p20240610 VALUES [('2024-06-10 00:00:00'), ('2024-06-11 00:00:00')),
PARTITION p20240611 VALUES [('2024-06-11 00:00:00'), ('2024-06-12 00:00:00')),
PARTITION p20240612 VALUES [('2024-06-12 00:00:00'), ('2024-06-13 00:00:00')),
PARTITION p20240613 VALUES [('2024-06-13 00:00:00'), ('2024-06-14 00:00:00')))
DISTRIBUTED BY HASH(`slot`, `info_type`) BUCKETS 8
PROPERTIES (
"replication_num" = "3",
"dynamic_partition.enable" = "true",
"dynamic_partition.time_unit" = "DAY",
"dynamic_partition.time_zone" = "Asia/Shanghai",
"dynamic_partition.start" = "-7",
"dynamic_partition.end" = "1",
"dynamic_partition.prefix" = "p",
"dynamic_partition.buckets" = "8",
"in_memory" = "false",
"storage_format" = "DEFAULT",
"enable_persistent_index" = "false"
);
